﻿

CREATE proc [dbo].[GetPaymentTypes]
@PaymentID int = null
as
begin
	set nocount on

	select	pt.PaymentID,
			pt.PaymentText
	from	dbo.domPaymentTypes pt
	where	pt.PaymentID = @PaymentID
				or @PaymentID is null
	return 0
end
GO
GRANT EXECUTE
    ON OBJECT::[dbo].[GetPaymentTypes] TO PUBLIC
    AS [dbo];

